[dbo].[BAECustomerValidateLogin]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECustomerValidateLogin

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@pUsername	varchar(60)	60
@pPassword	varchar(100)	100

SQL Script

create procedure [dbo].[BAECustomerValidateLogin] @pUsername as
varchar(60),
    @pPassword AS varchar(100)
AS
    SELECT ID FROM
    Name_Security
    WHERE
    WEB_LOGIN = @pUsername AND [PASSWORD] = @pPassword;

GO

Uses

[dbo].[Name_Security]
dbo